UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMkd6zXwU8+EGBiZIXgGMFTmkwvISG5CP5iHPv3YKq4='
WHERE
key_id = '490e8b0d3c21d28ae0ee569bd649d81cdfee98e948536fb1716290a2d028f3ea'
AND (
token = 'BMkd6zXwU8+EGBiZIXgGMFTmkwvISG5CP5iHPv3YKq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)