UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1/hi6Id+Zy6S0nm/hqIGAPWBn4Fx6eo/SmL6Br0KB70='
WHERE
key_id = '7f7ce8a1a15afcc2ef52a3de830ff65708d29c8612e1e20b2cb4b27e90faa818'
AND (
token = '1/hi6Id+Zy6S0nm/hqIGAPWBn4Fx6eo/SmL6Br0KB70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)