UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'erX1OMEmNwtcPdoXUs2cEyrR8evIc+XPRKB5LhlV7OU='
WHERE
key_id = '99f87b460b7bc04ff3273f6ce7216ccd7a10c6d852e0d6ffb037bd4debae7768'
AND (
token = 'erX1OMEmNwtcPdoXUs2cEyrR8evIc+XPRKB5LhlV7OU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)