UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H0kq9GLLJFDroz/5AtJtXf4ESc47T2kfkvhpxhH86Q8='
WHERE
key_id = '6f387d73ee40b89c8f86533c275a0daa3775fcfdaf2d75878d96f13e30e05465'
AND (
token = 'H0kq9GLLJFDroz/5AtJtXf4ESc47T2kfkvhpxhH86Q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)