UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rqwI+h13R+Y2pFOs43WVxVhuNup+u2vx9loPySN4Dz0=' 
WHERE 
  key_id = 'ede9638296a807cc2bac84674657d1f3c87d8450b8e5f4f14a3f4ce144a01014' 
  AND (
    token = 'rqwI+h13R+Y2pFOs43WVxVhuNup+u2vx9loPySN4Dz0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037