UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LhkQ4ujyFZOl7eEgpkMbY6Yxobg8Q1WARcUHBvL58b0='
WHERE
key_id = 'a520b02d65561ce26f6f42103e017ec3fc721d588eb15e761ba1f1b60fe8f780'
AND (
token = 'LhkQ4ujyFZOl7eEgpkMbY6Yxobg8Q1WARcUHBvL58b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)