UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uXnbye9M847rVKaVVFWrEeWFEMRG+QCN8JgxXvyLdeY='
WHERE
key_id = 'f3f75f395c08d39c465bc75f0001107c7bbbdd078df0c85633d179e42f02b12e'
AND (
token = 'uXnbye9M847rVKaVVFWrEeWFEMRG+QCN8JgxXvyLdeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)