UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CNoCRO9KiIj8USxHOn6FsMjDpg7aVjRAhgX7IrWBoyI='
WHERE
key_id = '1d6da9193acef8c37988577925950a7d3146c24c62862ad57e5fe5b10f465df8'
AND (
token = 'CNoCRO9KiIj8USxHOn6FsMjDpg7aVjRAhgX7IrWBoyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)