UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOSg7phy9NmYsOUQg3z1RdnZxwnJNYwq6HVEYLm/Fxs='
WHERE
key_id = 'e2bb0c1346b85e2ff35ca938054b360cf42393013bb0f3717b3e0a2710e8849a'
AND (
token = 'HOSg7phy9NmYsOUQg3z1RdnZxwnJNYwq6HVEYLm/Fxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)