UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8QIRhBzv0dbzE27HPCw33jOdW5nrlRSUaaPV5SVr14='
WHERE
key_id = '4e9de755a872a0dcc6858c8b847b8a95bd28df8f4f7428c6469681cea7cf1b43'
AND (
token = 'R8QIRhBzv0dbzE27HPCw33jOdW5nrlRSUaaPV5SVr14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)