UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KPS7D1B7DK6nMaeD3OD/GBTDVYmyRgRs8ZRqRqS9Mo0=' 
WHERE 
  key_id = '09307a2b3d70d03bff49673b52bc19d49e1201e5a0e5e7d9595f3d0032398917' 
  AND (
    token = 'KPS7D1B7DK6nMaeD3OD/GBTDVYmyRgRs8ZRqRqS9Mo0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023