UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0I7wFJRRUErLN3xEyZshW8QnJPTosAHO/bOIPUiP34='
WHERE
key_id = '4c72d8b6e6bf3994196bcec65255b058003946e2c70c6350194ca0e5d9ab8676'
AND (
token = 'a0I7wFJRRUErLN3xEyZshW8QnJPTosAHO/bOIPUiP34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)