UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8c9LNk9znIx3i2jrrhiaQqf26Y0J7HN+LGLrx0v2U8I='
WHERE
key_id = 'b77b18d0c7b7bc5a85f44a2dcb24d7d679bacb4138b4d92909977945ce17a781'
AND (
token = '8c9LNk9znIx3i2jrrhiaQqf26Y0J7HN+LGLrx0v2U8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)