UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6dW1iLpMmb1lMbPlf8q2b8atl2XjdbxR4t6+aJ766w='
WHERE
key_id = 'b163016bdb783bf222e15026e852e97b213f90944c132e58e3ecb4602d251b6c'
AND (
token = 'Z6dW1iLpMmb1lMbPlf8q2b8atl2XjdbxR4t6+aJ766w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)