UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wsWiyi64w4qYY34ixYh6oKs80GEBGv4xlFnDAx7LRUQ='
WHERE
key_id = 'bda3ca6cde79e1322b21b9ccad1b175cf885b0a041eb9cc6ae5bd18b02ea87fa'
AND (
token = 'wsWiyi64w4qYY34ixYh6oKs80GEBGv4xlFnDAx7LRUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)