UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4NL6Jfz6W0PUq4PCI8dqTIyV5r+0iHKd4MNwS7MWfRw='
WHERE
key_id = 'abd48a250efcc8e3d0eb6556baca4bdfbe2271e13d39c15e3405d95b34d1cb37'
AND (
token = '4NL6Jfz6W0PUq4PCI8dqTIyV5r+0iHKd4MNwS7MWfRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)