UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B1WDs6pFy3Bbpwl2HWnDfww/4a1z6kHw9vk6FA7jOBA='
WHERE
key_id = '4b6a06973a18037526f488b0388f1b80d9ef8e32c204ac79aa721c2736686ec0'
AND (
token = 'B1WDs6pFy3Bbpwl2HWnDfww/4a1z6kHw9vk6FA7jOBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)