UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Hqh3OCK+FgWjBavs/kfiE6BWs8Rk/S8uDLhyeWH14A='
WHERE
key_id = '92d8733cd3acf477010e60188bdb78a51cb89fa17413db401a69adbbec3e15b2'
AND (
token = '7Hqh3OCK+FgWjBavs/kfiE6BWs8Rk/S8uDLhyeWH14A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)