UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9acWSbxGNHBzflIbG1XRvOMLRuReE6I5Is8kwCm9hV0='
WHERE
key_id = '7c6962be358ae734d88cddb94c0381564f6bafa867be98071828d44d737156f0'
AND (
token = '9acWSbxGNHBzflIbG1XRvOMLRuReE6I5Is8kwCm9hV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)