UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCD7aoynC/iTJBNkaq8LwsBgEDjWLr3OP3JUhCeffHw='
WHERE
key_id = '8246773e4ef85a0c0727831220eae8c96a7c418f43c9c486f135032c5bdaed18'
AND (
token = 'YCD7aoynC/iTJBNkaq8LwsBgEDjWLr3OP3JUhCeffHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)