UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8WUQnr54wflFIoZb4afgYBK6EPyxWm5FsdeuLj2Vvo='
WHERE
key_id = '588d45b0cd1ea48f1f0200d2cbb9845f90ffd0895cb0b60ad9ec241c4ad67fb8'
AND (
token = 'N8WUQnr54wflFIoZb4afgYBK6EPyxWm5FsdeuLj2Vvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)