UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ztnvS207FzhNiHGGKkJnDOFDv4DeE7CM7fPp9aXtNkk='
WHERE
key_id = '3f14bdda4673a532e992a110f43d9b95c5201db063822a4ccfd7f401e7ae7dda'
AND (
token = 'ztnvS207FzhNiHGGKkJnDOFDv4DeE7CM7fPp9aXtNkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)