UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9EXTsUEFrveVOkXetJDT1/2ojylj0bP35y6RAyrL6w='
WHERE
key_id = 'd1adfba86837ff63c7b04d603caa0df71d1a615e7a25e8ed3969a50f60eed8f7'
AND (
token = 'p9EXTsUEFrveVOkXetJDT1/2ojylj0bP35y6RAyrL6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)