UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UR5Z+o07eBUBkoDRt+bkTtYPZozowvucqDJqLnhtzmk='
WHERE
key_id = '7307a92a1a75af90b6a0a1442253203de837379f9b43c17805de453b553f0cf1'
AND (
token = 'UR5Z+o07eBUBkoDRt+bkTtYPZozowvucqDJqLnhtzmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)