UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgkvRESeSq8MDm7Xe5y8ZdW5Z45pnXWnB12ZuSS5YVk='
WHERE
key_id = '236fc51740f89c6dc7e3b03a24d2674b21b2ff13ac1c74ef36a35097355e9351'
AND (
token = 'xgkvRESeSq8MDm7Xe5y8ZdW5Z45pnXWnB12ZuSS5YVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)