UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'znHYeEjJ1yMr+uVahE3N/S+y1dmIDRArTdX3x3778bM='
WHERE
key_id = '99f0da8e78e8d83272e3ea63147fee22f34f83730c51786a17f2ad11fd882188'
AND (
token = 'znHYeEjJ1yMr+uVahE3N/S+y1dmIDRArTdX3x3778bM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)