UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gBTcUOwzrtD6EBefeGSmBPHs/V6Uo7T7GAYgQSF8r00='
WHERE
key_id = '186784fc61be581d4e0ebdc8a7c44f0193a69e965f22fdf1420b37b5d0baeb13'
AND (
token = 'gBTcUOwzrtD6EBefeGSmBPHs/V6Uo7T7GAYgQSF8r00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)