UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lYI0zqqc6Ma5yy/qAgTAt/dRy/DXzXIZLCVy67sP+GM='
WHERE
key_id = '4a1d41e706c12d6575333e4b0710c1133154e69c7be07a858cc212212d8287d6'
AND (
token = 'lYI0zqqc6Ma5yy/qAgTAt/dRy/DXzXIZLCVy67sP+GM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)