UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ug557K1FIccl429qb7XJ1IVVpMlvUoFA2OOKAryv2yU='
WHERE
key_id = 'bf4bbaa564f74a64ddb6be72c240a192d8139995b3e61b99474dd519494f0439'
AND (
token = 'ug557K1FIccl429qb7XJ1IVVpMlvUoFA2OOKAryv2yU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)