UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHZu6y4/ChwXP1Lw2R7eyjdZSJ07xYCLbl7sI3Qb1+o='
WHERE
key_id = 'b227d783a61a76bc842821afd9e1aec642e6c1625b3cd98e3c33df9a3d156ebb'
AND (
token = 'xHZu6y4/ChwXP1Lw2R7eyjdZSJ07xYCLbl7sI3Qb1+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)