UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DX7/nUy8KCSHrAtbft/SiPE1MuGCOst4MFViKzGCTUo='
WHERE
key_id = 'e7370e5ee27ad5ba41016fd9e958876376c7e2dd44b0e0e8a953c331046fd3b6'
AND (
token = 'DX7/nUy8KCSHrAtbft/SiPE1MuGCOst4MFViKzGCTUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)