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